ILM Certificate in Leadership & Management (Business Analytics course Excel) Level 4

This certificate course comprehensively covers the use of business analytics using Microsoft Excel. Business analytics and ‘big data’ are fast becoming a critical business differentiator. Bain and Company and the Economist Intelligence Unit/SAS found that companies with the most analytics capabilities are outperforming competitors by wide profit margins. The course covers how to use business analytics to describe, identify and predict behaviour.

The course covers how to: (1) define the analytics problem, (2) acquire and blending datasets, (3) clean datasets, (4) use descriptive analytics, (5) use predictive analytics, and (6) present data and findings. The course is highly practical and uses provided sample datasets which students work on to firstly clean data and create a datawarehouse and then undertake a series of analytics tasks.

By choosing to study this ILM Certificate in Leadership and Management Business Analytics course with CMIT, students have 24×7 access to CMIT eLearning for the duration of the course. This includes a comprehensive Course Manual, Videos, Quizzes and personalised Tutor Support. The course documentation for this Business Analytics course is detailed and easy to read. You will also be able to upload assessments online and receive online feedback. You can use the eLearning system from any computer that has internet access.

Topics covered in this ILM Business Analytics course

1: Using business analytics

• Business analytics and big data
• Categories of analytics
• Descriptive analytics
• Predictive analytics
• Prescriptive analytics
• Challenges with implementation

Unit 2: Understanding data

• Secondary and primary data sources
• Quantitative and qualitative data
• Quantitative data types
• Cross–sectional and ‘time–series’ data

Unit 3: Preparing datasets

• Overview of the business analytics process
• The business analytics problem
• Dataset acquisition and blending
• Dataset cleaning

Unit 4: Exploring, mining and interpreting analytics

• Evaluating data
• Tables
• Cross-tabulations
• Bar charts
• Pie charts
• Line graphs
• Scatter chart
• Key statistics
• Correlation
• Predictive Models
• Presenting findings, conclusions and recommendations

Unit 5: Understanding the Organisational Culture and Context

• What is the organisation environment?
• PESTEL case studies
• Corporate culture
• Organisational ethics

Assessment

• This course is assessed through a series of tutor-marked assignments.
• All work submitted must be your own work. There is no exam with this course.
• As part of our quality assurance, learner assessment work will be marked by an Internal Assessor, then checked by an Internal Verifier and an External Verifier.

• Business Analysts, Data Analysts, Marketing and Digital Marketing professionals.
• Anyone interested in pursuing business analytics as a career.
• Digital, Web, e-Commerce, Social media and Mobile channel professionals.
• Those who wish to gain a professional, accredited qualification in the subject matter by home study distance learning.

• Level 3 certificate or equivalent qualification and/or relevant life and work experiences.
• As this is a Level 5 (UK) professional qualification, learners will be expected to reference their assignment work to a high academic standard.
• Candidates must be fluent in English with excellent written English Skills in order to achieve the assessment criteria.
• The assessments for this course draw on candidates own practical experience and as such candidates need to be working or have access to an organisation in which they can plan, execute and reflect on a number of management activities.

Currently there are no Q&As for this course. Be the first to ask a question.